Configuring and rebuilding property indexes

Configuring property indexes specifies which properties should be indexed for best performance. Rebuilding property indexes updates them with the metadata of new documents or object tags so that the new items can be found as quickly as older items. You only need to configure or rebuild property indexes after having cleared them as described in Disabling automatic indexing. You should rebuild the property indexes after you create or modify view filters as described in Creating and editing view filters.

When selecting the properties to index, observe the following guidelines:

• Do not select more properties than required. Selecting too many properties will negatively impact performance.
• Do not select properties for the lookup index that have many unique values. Property filtering works best with properties that have a limited number of distinct values (for example, size, location, department, and so on).

• Index the properties that are most likely to be used for searches in the Search pane (for example, the document number or file name).

  Note    By default, SQL Server does not recognize the hyphen (-) as a searchable character. If indexed properties will include values that contain hyphens (such as document numbers or filenames), you should configure a custom stoplist as described in the SQL Server documentation.

• The lookup index will only include the first 50 characters for each string value. Select only properties for this index that contain unique values for the first 50 characters.

To select properties for indexing and to rebuild the indexes:

1. In the BlueCielo Application Manager configuration tree, select Repositories\<Repository>\Documents\Document Properties or select Repositories\<Repository>\Object Tags\Object Tag Properties accordingly. The current property definitions appear.
2. Select the check box in the Indexed or Lookup index column for each property that you want to index.
3. When you are finished selecting the properties to index, click Apply to save your selections. The selected properties will be included in the indexes whenever the indexes are rebuilt.
4. Click Rebuild Indexes to rebuild the indexes immediately.